Item Data Import Template

Configuration > Utilities > Data Import Templates

The Item Data Import Template is used to import item information.
Note: This import can be followed by the Item with Ingredients import and/or the Ingredient Units of Measure import.

The following fields can be added to the Item Data Import Template:

Entity Model	Data Entity Mapping Type Required
Allergies	Allergy
Asset Account	Chart of Accounts
Barcode
Base Unit of Measure Name
Base Unit of Measure Weight
Base Unit of Measure Weight Type
Bid Specification	Bid Specification
Default Maximum Quantity
Default Minimum Quantity
Default Reorder Quantity
Description
Dietary Restrictions	Dietary Restrictions
District Groups	District Group
Expense Account	Chart of Accounts
Identifier
Ignore
Ingredient Weight
Ingredient Weight Type
Is Ingredient Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Inventoried Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Meal Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Published Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Purchased Item Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Recipe Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Reimbursable Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Sales Item Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Simple Recipe Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Item Category	Item Category
Item Tags
Manufacturer
Manufacturer Item Number
Name
Non-Student Income Account	Chart of Accounts
Point of Service Name
Preferred Unit of Measure Name
Preferred Unit of Measure Quantity
Preferred Vendor	Vendor
Preferred Vendor Cost
Preferred Vendor Discount
Preferred Vendor Handling Fee
Preferred Vendor Identifier
Preferred Vendor Is Local Food
Preferred Vendor is Taxable by Vendor
Preferred Vendor Is USDA Food
Preferred Vendor USDA Value
Preferred Vendor Unit of Measure
Recipe Category	Recipe Category
Religious Restrictions	Religious Restrictions
Secondary Vendor	Vendor
Secondary Vendor Cost
Secondary Vendor Discount	Preferred Vendor Discount
Secondary Vendor Handling Fee	Preferred Vendor Handling Fee
Secondary Vendor Identifier	Preferred Vendor Identifier
Secondary Vendor Is Local Food	Preferred Vendor Is Local Food
Secondary Vendor is Taxable by Vendor	Preferred Vendor is Taxable by Vendor
Secondary Vendor Is USDA Food	Preferred Vendor Is USDA Food
Secondary Vendor USDA Value	Preferred Vendor USDA Value
Secondary Vendor Unit of Measure	Preferred Vendor Unit of Measure
Student Income Account	Chart of Accounts
USDA Food Value
USDA Food Value Unit of Measure
Warehouse Item Template Note: Enter the item number of the Warehouse Item Template to be copied
Wbscm Number